/*
    Project Milestone 3
    by Lorenzo Miori [Lorenzo.Miori@stud-inf.unibz.it,
    Matteo Angriman [Matteo.Angriman@stud-inf.unibz.it],
    Nick Preda [Nicolae.Preda@stud-inf.unibz.it]
*/

package DB;

import static DB.GenericDBInterface.*;
import java.sql.Connection;
/**
 *
 * @author matteo
 */
public class RoomDB extends GenericTableInterface {
    /* Attribute names to be used in SQL query */
    public static final String ROOM_TABLE_NAME = "Room";
    public static final String ROOM_NO = "Room No.";
    public static final String ROOM_CAPACITY = "Capacity";
    public static final String ROOM_DESCRIPTION = "Description";
    public static final String ROOM_COST_PER_NIGHT = "Cost per Night";
    public static final String ROOM_ORDERING[] = {ROOM_NO, ROOM_CAPACITY, ROOM_DESCRIPTION, ROOM_COST_PER_NIGHT};
    /* Attribute types */
    public static final int[] ROOM_TYPES = {INT, INT, STRING, REAL};
    
    public RoomDB (Connection dbConnection){
    
        super(dbConnection, ROOM_TYPES, ROOM_NO, ROOM_TABLE_NAME, ROOM_ORDERING);
    
}
}
